SELECT [UserId], [Email], [PasswordHash], [PasswordSalt], [FirstName], [LastName], [MiddleInitial], [SecretQuestion1Id], [SecretQuestion2Id], [SecretAnswer1Hash], [SecretAnswer2Hash], [AccountTypeId], [AccountStatus], [Active], [CreationUserId], [CreationDateTime], [UpdateUserId], [UpdateDateTime] FROM [NPC].[dbo].[Users]

SELECT [AddressId], [Line1], [Line2], [City], [StateProvince], [CountryId], [Phone], [Fax], [Active], [CreationUserId], [CreationDateTime], [UpdateUserId], [UpdateDateTime] FROM [NPC].[dbo].[Addresses]

SELECT [UserId], [AddressId], [AddressTypeId] FROM [NPC].[dbo].[UserAddresses]

SELECT [RoleId], [UserId] FROM [NPC].[dbo].[UserRoles]